In SAS^® Customer Experience Targeting, the following code rounds large SK values, which causes incorrect values to be stored in the cxtcnfg.Internal_promo_sk_max_sk_values table.

When the code above fails, the following error message appears in the SAS Customer Experience Targeting CXT_ETL_cxt_2022_load_custom_attributes job:

To resume the ETL flows, follow the steps in this workaround:

1. Back up the cxtcnfg.Internal_promo_sk_max_sk_values and cxtcnfg.Internal_promotion_md5 tables.
2. Run the reset job, and save the log for future reference.
3. Submit the following code update.
   
   proc sql; update cxtcnfg.Internal_promo_sk_max_sk_values set sk_value=101470260 where sk_value=101470000; quit;
4. After the update runs, confirm that the value in the table for MAX(SK_VALUE) is 101470260.
5. Place the attached file in the ucmacros folder (which resides in a location similar to .../SASHome/SASFoundation/9.4/ucmacros/cxasvr/). You should see *_Clean_*.sas files in this directory.
6. Put the following SAS statement in the appserver_autoexec_usermods.sas file (which is located in a directory path similar to SAS-configuration-directory\Lev1\SASApp\).
   options mlogic mprint symbolgen;
   Adding this line enables you to go through the logs easily while you are debugging.
7. Run the ETL flow again.
8. If the flow fails, send all of the log files to SAS Technical Support.

Operating System and Release Information

A fix for this issue for SAS Customer Experience Targeting Server 6.4 is available at: